﻿<?xml version="1.0" encoding="UTF-8"?>
<form xmlns="http://www.evolutility.com" title="客户对账" icon="cube.gif" description="ExportOrImport">
  <data dbtable="MRP_Customer" splogin="asp.net membership" dbcolumnpk="ID" dborder="CustomerCode" sppaging="EvoSP_PagedItem @SQLselect, @SQLtable, @SQLfrom, @SQLwhere, @SQLorderby, @SQLpk, @pageid, @pagesize" />
  <panel label="客户列表" width="100">
    <field id="11111" type="text" typeid="5" label="客户编号" dbcolumn="CustomerCode" dbcolumnread="CustomerCode" maxlength="32" readonly="1" required="1" optional="" fpos="10" search="1" searchadv="1" searchlist="1" height="1" width="30" />
    <field id="1" type="text" typeid="5" label="公司名称" dbcolumn="CompanyName" dbcolumnread="CompanyName" maxlength="128" readonly="1" required="1" optional="" fpos="10" search="1" searchadv="1" searchlist="1" height="1" width="30" />
    <field id="2" type="text" typeid="5" label="业务联系人" dbcolumn="FirstContactName" dbcolumnread="FirstContactName" maxlength="64" readonly="1" required="1" optional="" fpos="20" search="1" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="4" type="text" typeid="5" label="业务联系人电话号码" dbcolumn="FirstContactPhone" dbcolumnread="FirstContactPhone" maxlength="50" readonly="1" required="" optional="" fpos="40" search="0" searchadv="1" searchlist="0" height="1" width="20" />
    <field id="134" type="lov" typeid="5" label="结算周期" dbcolumn="PayPeriod" dbcolumnread="PayPeriod1" defaultvalue="1"
dbtablelov="View_PayPeriod_List" dbcolumnreadlov="DisplayText" maxlength="0" readonly="1" required="1" optional="" fpos="30" search="0" searchadv="1" searchlist="0" height="1" width="30" />
    <field id="1314" type="lov" typeid="5" label="支付方式" dbcolumn="PaymentType" dbcolumnread="PaymentType1" defaultvalue="1"
dbtablelov="View_PaymentType_List" dbcolumnreadlov="DisplayText" maxlength="0" readonly="1" required="1" optional="" fpos="30" search="0" searchadv="1" searchlist="0" height="1" width="30" />
    <field id="2111" type="text" typeid="5" label="财务联系人姓名" dbcolumn="FinanceContactName" dbcolumnread="FinanceContactName" maxlength="64" readonly="1" required="1" optional="" fpos="20" search="1" searchadv="1" searchlist="0" height="1" width="20" />
    <field id="4111" type="text" typeid="5" label="财务联系人电话号码" dbcolumn="FinanceContactPhone" dbcolumnread="FinanceContactPhone" maxlength="64" readonly="1" required="" optional="" fpos="40" search="0" searchadv="1" searchlist="0" height="1" width="20" />
  </panel>
  <panel-details panelid="1" dbtabledetails="View_GetProductExportBill" dbcolumndetails="CustomerID" label="产品出库">
    <field id="36" panelid="1" type="text" typeid="5" label="送货单号" dbcolumn="DeliveryCode" dbcolumnread="DeliveryCode" maxlength="128" readonly="1" required="1" optional="" fpos="10" search="1" searchadv="1" searchlist="1" height="1" width="70" />
    <field id="1" panelid="1" type="text" typeid="5" label="公司名称" dbcolumn="CompanyName" dbcolumnread="CompanyName" maxlength="128" readonly="1" required="1" optional="" fpos="10" search="1" searchadv="1" searchlist="1" height="1" width="30" />
    <field id="1137" panelid="1" type="text" typeid="5" label="订单号" dbcolumn="OrderCode" dbcolumnread="OrderCode" maxlength="0" readonly="0" required="1" optional="" fpos="70" search="1" searchadv="1" searchlist="1" height="1" width="80" />
    <field id="158" panelid="1" type="datetime" typeid="17" label="送货时间" format="{0:d}" dbcolumn="DeliveryDate" dbcolumnread="DeliveryDate" maxlength="4" readonly="0" required="2" optional="" fpos="60" search="1" searchadv="1" searchlist="1" height="1" width="30" />
    <field id="153" panelid="1" type="lov" typeid="5" label="产品名称" dbcolumn="ProductID" dbcolumnread="PNameAndCode" dbcolumnreadlov="NameAndCode" dbwherelov="View_MaterialNameAndCode.MType=5" dbtablelov="View_MaterialNameAndCode" maxlength="2" readonly="0" required="1" optional="" fpos="20" search="1" searchadv="1" searchlist="1" height="1" width="60" />
    <field id="154" panelid="1" type="integer" typeid="10" label="实收数量" dbcolumn="SignOffQuantity" dbcolumnread="SignOffQuantity" maxlength="8" readonly="0" required="1" optional="" fpos="20" search="1" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="134" panelid="1" type="lov" typeid="5" label="订单类型" defaultvalue="3" dbcolumn="OrderType" dbcolumnread="OrderType1"
dbtablelov="View_OrderType_List" dbcolumnreadlov="DisplayText" maxlength="0" readonly="1" required="0" optional="" fpos="30" search="0" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="154" panelid="1" type="integer" typeid="10" label="出库数量" dbcolumn="SendOutQuantity" dbcolumnread="SendOutQuantity" maxlength="8" readonly="0" required="1" optional="" fpos="20" search="1" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="161" panelid="1" type="decimal" typeid="9" label="价格" dbcolumn="CurrentPrice" dbcolumnread="CurrentPrice" maxlength="4" readonly="0" required="1" optional="" fpos="30" search="" searchadv="1" searchlist="1" height="1" width="15" />
  </panel-details>
</form>

